﻿package com.vone.export;

import java.util.List;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;

import com.vone.dao.GetCompany;
import com.vone.entity.Basicdata;
import com.vone.entity.CsCoreLeaguerEdu;
import com.vone.export.until.ExcelStyle;
import com.vone.export.until.ExcelStyleHight;

//创建企业基本信息和概况，第一个sheet
public class CompanyBaseSheet {
	private Cell cell;
	private ExcelStyle excelstyle = null;
	private ExcelStyleHight excelstylehight = null;

	// 创建第一个sheeet
	public void getCompanySheet(Basicdata basicdatas) {
		excelstyle = new ExcelStyle();// 实例化样式
		excelstylehight = new ExcelStyleHight();// 实例化样式
		// 创建第一个sheet
		HSSFWorkbook wb = (HSSFWorkbook) ExportUntil.workbook;
		Sheet sheet = ExportUntil.workbook.createSheet("企业基本信息和概况");
		sheet.setColumnWidth(0, 40 * 256);
		sheet.setColumnWidth(1, 15 * 256);
		sheet.setColumnWidth(2, 15 * 256);
		sheet.setColumnWidth(3, 15 * 256);
		sheet.setColumnWidth(4, 15 * 256);
		sheet.setColumnWidth(5, 15 * 256);
		sheet.setColumnWidth(6, 15 * 256);
		sheet.setColumnWidth(7, 15 * 256);
		sheet.setColumnWidth(8, 15 * 256);
		sheet.setColumnWidth(9, 15 * 256);
		sheet.setColumnWidth(10, 15 * 256);
		String[] str = { "*企业名称", "*参赛行业领域", "*行政区域", "*属于国家高新区内的企业", "*属于国家孵化器内的企业", "*属于国家级大学科技园内的企业",
				"*科技部备案的众创空间内的企业", "*企业类型" };
		// 初始化
		String attrhightech = null;
		String attrhightech2 = null;
		String attrhightech3 = null;
		String attrhightech4 = null;
		String attrhightech5 = null;
		// 属于国家高新区内的企业
		if (basicdatas.getAttr_high_tech() != null) {
			attrhightech = GetCompany.getcsattributecompany(basicdatas.getAttr_high_tech()).getAttribute_name();
		} else {
			attrhightech = "否";
		}
		// 属于国家孵化器内的企业
		if (basicdatas.getAttr_incubator() != null) {
			attrhightech2 = GetCompany.getcsattributecompany(basicdatas.getAttr_incubator()).getAttribute_name();
		} else {
			attrhightech2 = "否";
		}
		// 属于国家级大学科技园内的企业
		if (basicdatas.getAttr_science_park() != null) {
			attrhightech3 = GetCompany.getcsattributecompany(basicdatas.getAttr_science_park()).getAttribute_name();
		} else {
			attrhightech3 = "否";
		}
		// 科技部备案的众创空间内的企业
		if (basicdatas.getAttr_maker_space() != null) {
			attrhightech4 = GetCompany.getcsattributecompany(basicdatas.getAttr_maker_space()).getAttribute_name();
		} else {
			attrhightech4 = "否";
		}
		// 企业类型
		if (basicdatas.getEnterprise_type_name() != null) {
			attrhightech5 = basicdatas.getEnterprise_type_name() + ":" + basicdatas.getEnterprise_type_child_name();
		} else {
			attrhightech4 = "否";
		}

		String[] str2 = { basicdatas.getCompany_name(), basicdatas.getField_name(),
				basicdatas.getProvince_name() + "省-" + basicdatas.getCity_name() + "市", attrhightech, attrhightech2,
				attrhightech3, attrhightech4, attrhightech5 };

		Row row0 = sheet.createRow(0);
		row0.setHeight((short) 800);
		cell = row0.createCell(0);
		cell.setCellValue("用户名：" + basicdatas.getUserName() + " 的企业基本信息和概况（" + basicdatas.getGroupType() + "_"
				+ basicdatas.getSubmitType() + "）");// 设置第一行的字体
		cell.setCellStyle(excelstyle.getCellStyleheader());// 设置样式
		sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 10));

		// 构建标题样式
		HSSFCellStyle tableCellStyle = wb.createCellStyle();
		tableCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 左右居中
		tableCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 上下居中
		HSSFFont tableFont = wb.createFont();// 构建字体
		tableFont.setFontName("宋体");// 设置字体
		tableFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);// 设置粗体
		tableFont.setFontHeightInPoints((short) 12);// 设置字体大小
		tableCellStyle.setFont(tableFont);// 应用到样式
		cell.setCellStyle(tableCellStyle);// 应用到单元格
		/*
		 * int onrownum1=sheet.getLastRowNum()+1; Row row1 = sheet.createRow(1);
		 * row1.setHeight((short) 800); cell = row1.createCell(0);
		 * cell.setCellValue(" * 用户名");// 设置第一行的字体
		 * cell.setCellStyle(excelstyle.getCellStyleheader());// 设置样式 cell =
		 * row1.createCell(1);
		 * cell.setCellValue(""+basicdatas.getUserName()+"");// 设置第一行的字体
		 * cell.setCellStyle(excelstyle.getCellStyleheader());// 设置样式
		 * sheet.addMergedRegion(new CellRangeAddress(onrownum1, onrownum1, 1,
		 * 10));
		 */
		for (int i = 0; i < str.length; i++) {
			int onrownum = sheet.getLastRowNum() + 1;
			Row row = sheet.createRow(onrownum);
			row.setHeight((short) 800);
			cell = row.createCell(0);
			cell.setCellValue("" + str[i] + ""); // 设置第一行的字体
			cell.setCellStyle(excelstyle.getCellStyleheader()); // 设置样式
			// 设置数据
			cell = row.createCell(1);
			cell.setCellValue("" + str2[i] + "");// 设置第一行的字体
			cell.setCellStyle(excelstyle.getCellStyleheader());// 设置样式
			sheet.addMergedRegion(new CellRangeAddress(onrownum, onrownum, 1, 10));
		}

		// 在sheet里创建第8行
		int onrowlatrow = sheet.getLastRowNum() + 1;
		HSSFRow row8 = (HSSFRow) sheet.createRow(onrowlatrow);
		row8.setHeight((short) 800);
		HSSFCell row8_cell_0 = row8.createCell(0);
		HSSFCell row8_cell_1 = row8.createCell(1);
		HSSFCell row8_cell_2 = row8.createCell(4);
		HSSFCell row8_cell_3 = row8.createCell(7);
		HSSFCell row8_cell_4 = row8.createCell(8);
		HSSFCell row8_cell_5 = row8.createCell(9);
		// 设置单元格内容
		row8_cell_0.setCellValue("*营业执照注册号统一社会信用代码");
		if (basicdatas.getBusiness_licence_num() != null && basicdatas.getBusiness_licence_num().length() > 0) {
			row8_cell_1.setCellValue(basicdatas.getBusiness_licence_num());// 需要插入的数据
		} else {
			row8_cell_1.setCellValue("无");// 需要插入的数据
		}
		// row8_cell_1.setCellValue(basicdatas.getBusiness_licence_num());//
		// 需要插入的数据
		row8_cell_2.setCellValue("*组织机构代码号/统一社会信用代码");
		if (basicdatas.getOranization_code() != null && basicdatas.getOranization_code().length() > 0) {
			row8_cell_3.setCellValue(basicdatas.getOranization_code());// 需要插入的数据
		} else {
			row8_cell_3.setCellValue("无");// 需要插入的数据
		}
		row8_cell_4.setCellValue("成立时间");
		if (basicdatas.getFound_time() != null && basicdatas.getFound_time().length() > 0) {
			row8_cell_5.setCellValue(basicdatas.getFound_time());
		} else {
			row8_cell_5.setCellValue("无");
		}

		// 应用样式
		row8_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row8_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row8_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row8_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row8_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row8_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow, onrowlatrow, 1, 3));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow, onrowlatrow, 4, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow, onrowlatrow, 9, 10));

		// 在sheet里创建第9行
		int onrowlatrow2 = sheet.getLastRowNum() + 1;
		HSSFRow row9 = (HSSFRow) sheet.createRow(onrowlatrow2);
		row9.setHeight((short) 800);
		HSSFCell row9_cell_0 = row9.createCell(0);
		HSSFCell row9_cell_1 = row9.createCell(1);
		HSSFCell row9_cell_2 = row9.createCell(4);
		HSSFCell row9_cell_3 = row9.createCell(7);
		// 设置单元格内容
		row9_cell_0.setCellValue("*注册资本(万元人民币)");
		row9_cell_1.setCellValue(ExportUntil.getneedvalue(basicdatas.getRegistered_capital()));// 需要插入的数据
		row9_cell_2.setCellValue("实收资本(万元人民币)");

		row9_cell_3.setCellValue(ExportUntil.getneedvalue(basicdatas.getPaid_in_capital()));// 需要插入的数据
		// 应用样式
		row9_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row9_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row9_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row9_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow2, onrowlatrow2, 1, 3));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow2, onrowlatrow2, 4, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow2, onrowlatrow2, 7, 10));

		// 在sheet里创建第10行
		int onrowlatrow3 = sheet.getLastRowNum() + 1;
		HSSFRow row10 = (HSSFRow) sheet.createRow(onrowlatrow3);
		row10.setHeight((short) 800);
		HSSFCell row10_cell_0 = row10.createCell(0);
		HSSFCell row10_cell_1 = row10.createCell(1);
		HSSFCell row10_cell_2 = row10.createCell(7);
		HSSFCell row10_cell_3 = row10.createCell(10);
		// 设置单元格内容
		row10_cell_0.setCellValue("*注册地址");
		row10_cell_1.setCellValue(ExportUntil.getneedvalue(basicdatas.getRegistered_address()));// 需要插入的数据
		row10_cell_2.setCellValue("邮政编码");
		row10_cell_3.setCellValue(ExportUntil.getneedvalue(basicdatas.getRegistered_postcode()));// 需要插入的数据
		// 应用样式
		row10_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row10_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row10_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row10_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow3, onrowlatrow3, 1, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow3, onrowlatrow3, 7, 9));

		// 在sheet里创建第11行
		int onrowlatrow4 = sheet.getLastRowNum() + 1;
		HSSFRow row11 = (HSSFRow) sheet.createRow(onrowlatrow4);
		row11.setHeight((short) 800);
		HSSFCell row11_cell_0 = row11.createCell(0);
		HSSFCell row11_cell_1 = row11.createCell(1);
		HSSFCell row11_cell_2 = row11.createCell(7);
		HSSFCell row11_cell_3 = row11.createCell(10);
		// 设置单元格内容
		row11_cell_0.setCellValue("*办公地址");
		row11_cell_1.setCellValue(ExportUntil.getneedvalue(basicdatas.getOffice_address()));// 需要插入的数据
		row11_cell_2.setCellValue("邮政编码");
		row11_cell_3.setCellValue(ExportUntil.getneedvalue(basicdatas.getOffice_postcode()));// 需要插入的数据
		// 应用样式
		row11_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row11_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row11_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row11_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow4, onrowlatrow4, 1, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow4, onrowlatrow4, 7, 9));

		// 在sheet里创建第12行
		int onrowlatrow5 = sheet.getLastRowNum() + 1;
		HSSFRow row12 = (HSSFRow) sheet.createRow(onrowlatrow5);
		row12.setHeight((short) 800);
		HSSFCell row12_cell_0 = row12.createCell(0);
		HSSFCell row12_cell_1 = row12.createCell(1);
		HSSFCell row12_cell_2 = row12.createCell(4);
		HSSFCell row12_cell_3 = row12.createCell(6);
		// 设置单元格内容
		row12_cell_0.setCellValue("企业网址");
		row12_cell_1.setCellValue(ExportUntil.getneedvalue(basicdatas.getWebsite()));// 需要插入的数据
		row12_cell_2.setCellValue("企业官方微信");
		row12_cell_3.setCellValue(ExportUntil.getneedvalue(basicdatas.getWechat()));// 需要插入的数据
		// 应用样式
		row12_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row12_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row12_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row12_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow5, onrowlatrow5, 1, 3));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow5, onrowlatrow5, 4, 5));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow5, onrowlatrow5, 6, 10));

		// 在sheet里创建第13行
		int onrowlatrow6 = sheet.getLastRowNum() + 1;
		HSSFRow row13 = (HSSFRow) sheet.createRow(onrowlatrow6);
		row13.setHeight((short) 800);
		HSSFCell row13_cell_0 = row13.createCell(0);
		HSSFCell row13_cell_1 = row13.createCell(1);
		// 设置单元格内容
		row13_cell_0.setCellValue("参赛目的");
		row13_cell_1.setCellValue(ExportUntil.getneedvalue(basicdatas.getPurpose_name()));// 需要插入的数据
		// 应用样式
		row13_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row13_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow6, onrowlatrow6, 1, 10));

		// 在sheet里创建第14行
		int onrowlatrow7 = sheet.getLastRowNum() + 1;
		HSSFRow row14 = (HSSFRow) sheet.createRow(onrowlatrow7);
		row14.setHeight((short) 800);
		HSSFCell row14_cell_0 = row14.createCell(0);
		HSSFCell row14_cell_1 = row14.createCell(1);
		HSSFCell row14_cell_2 = row14.createCell(2);
		HSSFCell row14_cell_4 = row14.createCell(4);
		HSSFCell row14_cell_5 = row14.createCell(5);
		HSSFCell row14_cell_6 = row14.createCell(6);
		HSSFCell row14_cell_7 = row14.createCell(7);
		HSSFCell row14_cell_8 = row14.createCell(8);
		HSSFCell row14_cell_10 = row14.createCell(10);
		// 设置单元格内容
		// row14_cell_0.setCellValue("参赛目的");
		row14_cell_1.setCellValue("姓名");
		row14_cell_2.setCellValue("性别");
		row14_cell_4.setCellValue("年龄");
		row14_cell_5.setCellValue("学历");
		row14_cell_6.setCellValue("职位");
		row14_cell_7.setCellValue("办公电话");
		row14_cell_8.setCellValue("手机");
		row14_cell_10.setCellValue("电子邮件");
		// 应用样式
		// row14_cell_0.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格
		row14_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_6.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_7.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row14_cell_10.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow7, onrowlatrow7, 2, 3));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow7, onrowlatrow7, 8, 9));

		// 在sheet里创建第15行
		int onrowlatrow8 = sheet.getLastRowNum() + 1;
		HSSFRow row15 = (HSSFRow) sheet.createRow(onrowlatrow8);
		row15.setHeight((short) 800);
		HSSFCell row15_cell_0 = row15.createCell(0);
		HSSFCell row15_cell_1 = row15.createCell(1);
		HSSFCell row15_cell_2 = row15.createCell(2);
		HSSFCell row15_cell_4 = row15.createCell(4);
		HSSFCell row15_cell_5 = row15.createCell(5);
		HSSFCell row15_cell_6 = row15.createCell(6);
		HSSFCell row15_cell_7 = row15.createCell(7);
		HSSFCell row15_cell_8 = row15.createCell(8);
		HSSFCell row15_cell_10 = row15.createCell(10);
		// 设置单元格内容
		row15_cell_0.setCellValue("*法定代表人");
		if (basicdatas.getCscompanyPerson() != null) {
			for (int i = 0; i < basicdatas.getCscompanyPerson().size(); i++) {
				if ("1".equals(basicdatas.getCscompanyPerson().get(i).getPerson_type())) {
					row15_cell_1.setCellValue(
							ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getPerson_name()));
					if (basicdatas.getCscompanyPerson().get(i).getSex().equals("1")) {
						row15_cell_2.setCellValue("男");
					}
					if (basicdatas.getCscompanyPerson().get(i).getSex().equals("2")) {
						row15_cell_2.setCellValue("女");
					}
					row15_cell_4.setCellValue(basicdatas.getCscompanyPerson().get(i).getAge());
					// row15_cell_5.setCellValue(basicdatas.getCscompanyPerson().get(i).getDegree_id());
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("116")) {
						row15_cell_5.setCellValue("本科");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("111")) {
						row15_cell_5.setCellValue("博士");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("32")) {
						row15_cell_5.setCellValue("大专");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("28")) {
						row15_cell_5.setCellValue("硕士");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("34")) {
						row15_cell_5.setCellValue("其他");
					}
					row15_cell_6
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getPost()));
					row15_cell_7.setCellValue(
							ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getLandline()));
					row15_cell_8
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getMobile()));
					row15_cell_10
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getEmail()));
				}
			}
		}

		// 应用样式
		row15_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_6.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_7.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row15_cell_10.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow8, onrowlatrow8, 2, 3));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow8, onrowlatrow8, 8, 9));

		// 在sheet里创建第16行

		int onrowlatrow9 = sheet.getLastRowNum() + 1;
		HSSFRow row16 = (HSSFRow) sheet.createRow(onrowlatrow9);
		row16.setHeight((short) 800);
		HSSFCell row16_cell_0 = row16.createCell(0);
		HSSFCell row16_cell_1 = row16.createCell(1);
		HSSFCell row16_cell_2 = row16.createCell(2);
		HSSFCell row16_cell_4 = row16.createCell(4);
		HSSFCell row16_cell_5 = row16.createCell(5);
		HSSFCell row16_cell_6 = row16.createCell(6);
		HSSFCell row16_cell_7 = row16.createCell(7);
		HSSFCell row16_cell_8 = row16.createCell(8);
		HSSFCell row16_cell_10 = row16.createCell(10);
		// 设置单元格内容
		row16_cell_0.setCellValue("*企业负责人");
		if (basicdatas.getCscompanyPerson() != null) {
			for (int i = 0; i < basicdatas.getCscompanyPerson().size(); i++) {
				if ("2".equals(basicdatas.getCscompanyPerson().get(i).getPerson_type())) {
					row16_cell_1.setCellValue(
							ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getPerson_name()));
					// row16_cell_2.setCellValue(basicdatas.getCscompanyPerson().get(i).getSex());
					if (basicdatas.getCscompanyPerson().get(i).getSex().equals("1")) {
						row16_cell_2.setCellValue("男");
					} else {
						row16_cell_2.setCellValue("女");
					}
					row16_cell_4.setCellValue(basicdatas.getCscompanyPerson().get(i).getAge());
					// row16_cell_5.setCellValue(basicdatas.getCscompanyPerson().get(i).getDegree_id());
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("116")) {
						row16_cell_5.setCellValue("本科");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("111")) {
						row16_cell_5.setCellValue("博士");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("32")) {
						row16_cell_5.setCellValue("大专");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("28")) {
						row16_cell_5.setCellValue("硕士");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("34")) {
						row16_cell_5.setCellValue("其他");
					}
					row16_cell_6
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getPost()));
					row16_cell_7.setCellValue(
							ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getLandline()));
					row16_cell_8
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getMobile()));
					row16_cell_10
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getEmail()));
				}
			}
		}
		// 应用样式
		row16_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_6.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_7.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row16_cell_10.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow9, onrowlatrow9, 2, 3));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow9, onrowlatrow9, 8, 9));

		// 在sheet里创建第17行
		int onrowlatrow10 = sheet.getLastRowNum() + 1;
		HSSFRow row17 = (HSSFRow) sheet.createRow(onrowlatrow10);
		row17.setHeight((short) 800);
		HSSFCell row17_cell_0 = row17.createCell(0);
		HSSFCell row17_cell_1 = row17.createCell(1);
		HSSFCell row17_cell_2 = row17.createCell(2);
		HSSFCell row17_cell_4 = row17.createCell(4);
		HSSFCell row17_cell_5 = row17.createCell(5);
		HSSFCell row17_cell_6 = row17.createCell(6);
		HSSFCell row17_cell_7 = row17.createCell(7);
		HSSFCell row17_cell_8 = row17.createCell(8);
		HSSFCell row17_cell_10 = row17.createCell(10);
		// 设置单元格内容
		row17_cell_0.setCellValue("*联系人");
		if (basicdatas.getCscompanyPerson() != null) {
			for (int i = 0; i < basicdatas.getCscompanyPerson().size(); i++) {
				if ("3".equals(basicdatas.getCscompanyPerson().get(i).getPerson_type())) {
					row17_cell_1.setCellValue(basicdatas.getCscompanyPerson().get(i).getPerson_name());
					if (basicdatas.getCscompanyPerson().get(i).getSex().equals("1")) {
						row17_cell_2.setCellValue("男");
					} else {
						row17_cell_2.setCellValue("女");
					}
					row17_cell_4.setCellValue(basicdatas.getCscompanyPerson().get(i).getAge());
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("116")) {
						row17_cell_5.setCellValue("本科");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("111")) {
						row17_cell_5.setCellValue("博士");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("32")) {
						row17_cell_5.setCellValue("大专");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("28")) {
						row17_cell_5.setCellValue("硕士");
					}
					if (basicdatas.getCscompanyPerson().get(i).getDegree_id().equals("34")) {
						row17_cell_5.setCellValue("其他");
					}
					// row17_cell_5.setCellValue(basicdatas.getCscompanyPerson().get(i).getDegree_id());
					row17_cell_6
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getPost()));
					row17_cell_7.setCellValue(
							ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getLandline()));
					row17_cell_8
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getMobile()));
					row17_cell_10
							.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyPerson().get(i).getEmail()));
				}
			}
		}
		// 应用样式
		row17_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_6.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_7.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row17_cell_10.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow10, onrowlatrow10, 2, 3));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow10, onrowlatrow10, 8, 9));

		// 在sheet里创建第18行
		int onrowlatrow11 = sheet.getLastRowNum() + 1;
		HSSFRow row18 = (HSSFRow) sheet.createRow(onrowlatrow11);
		row18.setHeight((short) 7500);
		HSSFCell row18_cell_0 = row18.createCell(0);
		HSSFCell row18_cell_1 = row18.createCell(1);
		// 设置单元格内容
		row18_cell_0.setCellValue("企业概要(不超过1000字)");
		row18_cell_1.setCellValue(basicdatas.getOutline());// 需要插入的数据
		// 应用样式
		row18_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row18_cell_1.setCellStyle(excelstylehight.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow11, onrowlatrow11, 1, 10));

		// 在sheet里创建第19行

		int onrowlatrow12 = sheet.getLastRowNum() + 1;
		HSSFRow row19 = (HSSFRow) sheet.createRow(onrowlatrow12);
		row19.setHeight((short) 800);
		HSSFCell row19_cell_0 = row19.createCell(0);
		HSSFCell row19_cell_1 = row19.createCell(1);
		HSSFCell row19_cell_2 = row19.createCell(3);
		HSSFCell row19_cell_3 = row19.createCell(6);
		HSSFCell row19_cell_4 = row19.createCell(7);
		HSSFCell row19_cell_5 = row19.createCell(10);
		// HSSFCell row19_cell_5 = row19.createCell(11);
		// 设置单元格内容
		row19_cell_0.setCellValue("员工总数");
		row19_cell_1.setCellValue(ExportUntil.getneedvalue(basicdatas.getEmployee_sum()));// 需要插入的数据
		row19_cell_2.setCellValue("大专以上科技人员数");
		row19_cell_3.setCellValue(ExportUntil.getneedvalue(basicdatas.getCollege_above_sum()));// 需要插入的数据
		row19_cell_4.setCellValue("直接从事研发科技人员数");
		row19_cell_5.setCellValue(ExportUntil.getneedvalue(basicdatas.getDevelopers_sum()));
		// row19_cell_5.setCellValue("");
		// 应用样式
		row19_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row19_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row19_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row19_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row19_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row19_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// row19_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow12, onrowlatrow12, 1, 2));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow12, onrowlatrow12, 3, 5));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow12, onrowlatrow12, 7, 9));

		// 在sheet里创建第20行
		int onrowlatrow13 = sheet.getLastRowNum() + 1;
		HSSFRow row20 = (HSSFRow) sheet.createRow(onrowlatrow13);
		row20.setHeight((short) 800);
		HSSFCell row20_cell_0 = row20.createCell(0);
		HSSFCell row20_cell_1 = row20.createCell(1);
		HSSFCell row20_cell_2 = row20.createCell(3);
		HSSFCell row20_cell_4 = row20.createCell(7);
		HSSFCell row20_cell_5 = row20.createCell(10);
		// 设置单元格内容
		row20_cell_0.setCellValue("上市公司控股企业");
		if (basicdatas.getListed_type_name() != null) {
			row20_cell_1.setCellValue("是");// 需要插入的数据

		} else {
			row20_cell_1.setCellValue("否");// 需要插入的数据
		}

		row20_cell_2.setCellValue(ExportUntil.getneedvalue(basicdatas.getListed_type_id()));
		row20_cell_4.setCellValue("新三板企业");
		if (basicdatas.getIs_neeq() != null) {
			if ("0".equals(basicdatas.getIs_neeq())) {
				row20_cell_5.setCellValue("否");
			} else if ("1".equals(basicdatas.getIs_neeq())) {
				row20_cell_5.setCellValue("是");
			}
		}

		// 应用样式
		row20_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row20_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row20_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row20_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row20_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow13, onrowlatrow13, 1, 2));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow13, onrowlatrow13, 3, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow13, onrowlatrow13, 7, 9));

		// 在sheet里创建第21行
		int onrowlatrow14 = sheet.getLastRowNum() + 1;
		HSSFRow row21 = (HSSFRow) sheet.createRow(onrowlatrow14);
		row21.setHeight((short) 800);
		HSSFCell row21_cell_0 = row21.createCell(0);
		HSSFCell row21_cell_1 = row21.createCell(1);
		HSSFCell row21_cell_2 = row21.createCell(3);
		HSSFCell row21_cell_4 = row21.createCell(7);
		// 设置单元格内容
		row21_cell_0.setCellValue("*高薪技术企业");
		if (basicdatas.getHigh_tech_rcv_time() != null) {
			row21_cell_1.setCellValue("是");// 需要插入的数据
		} else {
			row21_cell_1.setCellValue("否");// 需要插入的数据
		}
		row21_cell_2.setCellValue("获得时间");
		if (basicdatas.getHigh_tech_rcv_time() != null) {
			row21_cell_4.setCellValue(basicdatas.getHigh_tech_rcv_time());
		} else {
			row21_cell_4.setCellValue("无");
		}

		// 应用样式
		row21_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row21_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row21_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row21_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow14, onrowlatrow14, 1, 2));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow14, onrowlatrow14, 3, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow14, onrowlatrow14, 7, 10));

		// 在sheet里创建第22行
		int onrowlatrow15 = sheet.getLastRowNum() + 1;
		HSSFRow row22 = (HSSFRow) sheet.createRow(onrowlatrow15);
		row22.setHeight((short) 800);
		HSSFCell row22_cell_0 = row22.createCell(0);
		HSSFCell row22_cell_1 = row22.createCell(1);
		HSSFCell row22_cell_2 = row22.createCell(3);
		HSSFCell row22_cell_4 = row22.createCell(7);
		// 设置单元格内容
		row22_cell_0.setCellValue("拥有国家或省级研发机构情况表(可增加)");
		row22_cell_1.setCellValue("*研发机构名称");
		row22_cell_2.setCellValue("研发机构级别");// 需要插入的数据
		row22_cell_4.setCellValue("证明文件名称");

		// 应用样式
		row22_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row22_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row22_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row22_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow15, onrowlatrow15 + 1, 0, 0));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow15, onrowlatrow15, 1, 2));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow15, onrowlatrow15, 3, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow15, onrowlatrow15, 7, 10));

		// 在sheet里创建第23行
		int onrowlatrow16 = sheet.getLastRowNum() + 1;
		HSSFRow row23 = (HSSFRow) sheet.createRow(onrowlatrow16);
		row23.setHeight((short) 800);
		HSSFCell row23_cell_0 = row23.createCell(0);
		HSSFCell row23_cell_1 = row23.createCell(1);
		HSSFCell row23_cell_2 = row23.createCell(3);
		HSSFCell row23_cell_4 = row23.createCell(7);
		// 设置单元格内容
		// row23_cell_0.setCellValue("*高薪技术企业");
		if (basicdatas.getResearchsituation() != null) {
			row23_cell_1.setCellValue(basicdatas.getResearchsituation().getName());// 需要插入的数据
			row23_cell_2.setCellValue(basicdatas.getResearchsituation().getLevel());
			row23_cell_4.setCellValue(basicdatas.getResearchsituation().getFile_name());
		} else {
			row23_cell_1.setCellValue("无");// 需要插入的数据
			row23_cell_2.setCellValue("无");
			row23_cell_4.setCellValue("无");
		}

		// 应用样式
		row23_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row23_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row23_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row23_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow16, onrowlatrow16, 1, 2));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow16, onrowlatrow16, 3, 6));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow16, onrowlatrow16, 7, 10));

		// 在sheet里创建第22行
		int onrowlatrow17 = sheet.getLastRowNum() + 1;
		HSSFRow row24 = (HSSFRow) sheet.createRow(onrowlatrow17);
		row24.setHeight((short) 800);
		HSSFCell row24_cell_0 = row24.createCell(0);
		HSSFCell row24_cell_1 = row24.createCell(1);
		HSSFCell row24_cell_2 = row24.createCell(8);
		// 设置单元格内容
		row24_cell_0.setCellValue("*获奖与支持");
		row24_cell_1.setCellValue("获奖名称");
		row24_cell_2.setCellValue("获得时间");// 需要插入的数据
		// 应用样式
		row24_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row24_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row24_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow17, onrowlatrow17, 1, 7));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow17, onrowlatrow17, 8, 10));

		// 在sheet里创建第22行
		int onrowlatrow18 = sheet.getLastRowNum() + 1;
		HSSFRow row25 = (HSSFRow) sheet.createRow(onrowlatrow18);
		row25.setHeight((short) 800);
		HSSFCell row25_cell_0 = row25.createCell(0);
		HSSFCell row25_cell_1 = row25.createCell(1);
		HSSFCell row25_cell_2 = row25.createCell(8);
		// 设置单元格内容
		// row25_cell_0.setCellValue("*获奖与支持");
		row25_cell_1.setCellValue("自行填写国家级和省部级获得的奖项：无");
		row25_cell_2.setCellValue("无");// 需要插入的数据

		if (basicdatas.getCscompanyprize() != null) {
			for (int i = 0; i < basicdatas.getCscompanyprize().size(); i++) {
				if ("1".equals(basicdatas.getCscompanyprize().get(i).getType())) {
					row25_cell_1.setCellValue("自行填写国家级和省部级获得的奖项："
							+ ExportUntil.getneedvalue(basicdatas.getCscompanyprize().get(i).getName()));
					row25_cell_2.setCellValue(
							ExportUntil.getneedvalue(basicdatas.getCscompanyprize().get(i).getReceive_time()));// 需要插入的数据
					// System.err.println("1:"+basicdatas.getCscompanyprize().get(i).getType()+"
					// "+basicdatas.getCscompanyprize().get(i).getName()+"
					// "+basicdatas.getCscompanyprize().get(i).getReceive_time());
				}
			}
		}
		// 应用样式
		row25_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row25_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row25_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow18, onrowlatrow18, 1, 7));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow18, onrowlatrow18, 8, 10));

		// 在sheet里创建第22行
		int onrowlatrow19 = sheet.getLastRowNum() + 1;
		HSSFRow row26 = (HSSFRow) sheet.createRow(onrowlatrow19);
		row26.setHeight((short) 800);
		HSSFCell row26_cell_0 = row26.createCell(0);
		HSSFCell row26_cell_1 = row26.createCell(1);
		HSSFCell row26_cell_2 = row26.createCell(8);
		row26_cell_1.setCellValue("企业或个人曾获得国家级，省部级奖项，及其他计划等奖项:无");
		row26_cell_2.setCellValue("无");// 需要插入的数据
		// 设置单元格内容
		if (basicdatas.getCscompanyprize() != null) {
			for (int i = 0; i < basicdatas.getCscompanyprize().size(); i++) {
				if ("2".equals(basicdatas.getCscompanyprize().get(i).getType())) {
					row26_cell_1.setCellValue("企业或个人曾获得国家级，省部级奖项，及其他计划等奖项:"
							+ ExportUntil.getneedvalue(basicdatas.getCscompanyprize().get(i).getName()));
					row26_cell_2.setCellValue(
							ExportUntil.getneedvalue(basicdatas.getCscompanyprize().get(i).getReceive_time()));// 需要插入的数据
				}
			}
		}
		// 应用样式
		row26_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row26_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row26_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow19, onrowlatrow19, 1, 7));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow19, onrowlatrow19, 8, 10));

		// 在sheet里创建第22行
		int onrowlatrow20 = sheet.getLastRowNum() + 1;
		HSSFRow row27 = (HSSFRow) sheet.createRow(onrowlatrow20);
		row27.setHeight((short) 800);
		HSSFCell row27_cell_0 = row27.createCell(0);
		HSSFCell row27_cell_1 = row27.createCell(1);
		HSSFCell row27_cell_2 = row27.createCell(8);
		// 设置单元格内容
		// row27_cell_0.setCellValue("*获奖与支持");
		row27_cell_1.setCellValue("曾经承担的或者正在承担的：无");
		row27_cell_2.setCellValue("无");// 需要插入的数据
		
		if (basicdatas.getCscompanyprize() != null) {
			for (int i = 0; i < basicdatas.getCscompanyprize().size(); i++) {
				if ("3".equals(basicdatas.getCscompanyprize().get(i).getType())) {
					
					Map<String,String> evevbaer = GetCompany.getevenbear(basicdatas.getCscompanyprize().get(i).getPrize_type_id());
					
					row27_cell_1.setCellValue("曾经承担的或者正在承担的："+ExportUntil.getneedvalue(evevbaer.get("name")));
					row27_cell_2.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscompanyprize().get(i).getReceive_time()));// 需要插入的数据
				}
			}
		}
		// 应用样式
		row27_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row27_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row27_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow20, onrowlatrow20, 1, 7));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow20, onrowlatrow20, 8, 10));
		sheet.addMergedRegion(new CellRangeAddress(onrowlatrow17, sheet.getLastRowNum(), 0, 0));

		int celllastrownum = sheet.getLastRowNum() + 1;
		// 在sheet里创建第22行
		HSSFRow row29 = (HSSFRow) sheet.createRow(celllastrownum);
		row29.setHeight((short) 800);
		HSSFCell row29_cell_0 = row29.createCell(0);
		HSSFCell row29_cell_1 = row29.createCell(1);
		HSSFCell row29_cell_2 = row29.createCell(3);
		HSSFCell row29_cell_3 = row29.createCell(5);
		HSSFCell row29_cell_4 = row29.createCell(8);
		HSSFCell row29_cell_5 = row29.createCell(9);
		// 设置单元格内容
		row29_cell_0.setCellValue("*核心技术");
		row29_cell_1.setCellValue("专利");
		row29_cell_2.setCellValue("专利名");// 需要插入的数据
		row29_cell_3.setCellValue("专利类型");
		row29_cell_4.setCellValue("专利号");
		row29_cell_5.setCellValue("获得时间");
		// 应用样式
		row29_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row29_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row29_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row29_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row29_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row29_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(celllastrownum, celllastrownum, 3, 4));// 专利类型
		sheet.addMergedRegion(new CellRangeAddress(celllastrownum, celllastrownum, 5, 7));// 专利号
		sheet.addMergedRegion(new CellRangeAddress(celllastrownum, celllastrownum, 9, 10));// 获得时间

		int onzlrow = sheet.getLastRowNum() + 1;
		int softsizezl = 0;
		if (basicdatas.getCscoretecpatent() != null) {
			softsizezl = basicdatas.getCscoretecpatent().size();
			for (int i = 0; i < softsizezl; i++) {
				HSSFRow row30 = (HSSFRow) sheet.createRow(onzlrow + i);
				row30.setHeight((short) 800);
				HSSFCell row30_cell_3 = row30.createCell(3);
				HSSFCell row30_cell_5 = row30.createCell(5);
				HSSFCell row30_cell_8 = row30.createCell(8);
				HSSFCell row30_cell_9 = row30.createCell(9);
				row30_cell_3
						.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscoretecpatent().get(i).getPatent_name()));// 需要插入的数据
				row30_cell_5
						.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscoretecpatent().get(i).getOption_name()));
				row30_cell_8.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscoretecpatent().get(i).getPatent_num()));
				row30_cell_9
						.setCellValue(ExportUntil.getneedvalue(basicdatas.getCscoretecpatent().get(i).getReceive_time()));
				sheet.addMergedRegion(new CellRangeAddress(onzlrow + i, onzlrow + i, 3, 4));
				sheet.addMergedRegion(new CellRangeAddress(onzlrow + i, onzlrow + i, 5, 7));
				sheet.addMergedRegion(new CellRangeAddress(onzlrow + i, onzlrow + i, 9, 10));

				row30_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_9.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格

			}
		}else{
			softsizezl=1;
			
			int onzlronum=sheet.getLastRowNum()+1;
			HSSFRow row30 = (HSSFRow) sheet.createRow(onzlronum);
			row30.setHeight((short) 800);
			HSSFCell row30_cell_3 = row30.createCell(3);
			HSSFCell row30_cell_5 = row30.createCell(5);
			HSSFCell row30_cell_8 = row30.createCell(8);
			HSSFCell row30_cell_9 = row30.createCell(9);
			row30_cell_3
					.setCellValue("无");// 需要插入的数据
			row30_cell_5
					.setCellValue("无");
			row30_cell_8.setCellValue("无");
			row30_cell_9.setCellValue("无");
			sheet.addMergedRegion(new CellRangeAddress(onzlronum , onzlronum , 3, 4));
			sheet.addMergedRegion(new CellRangeAddress(onzlronum , onzlronum , 5, 7));
			sheet.addMergedRegion(new CellRangeAddress(onzlronum , onzlronum , 9, 10));

			row30_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_9.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		}
		
		
		

		// 在sheet里创建第22行
		int zlsmonrow = sheet.getLastRowNum() + 1;
		HSSFRow row33 = (HSSFRow) sheet.createRow(zlsmonrow);
		row33.setHeight((short) 800);
		HSSFCell row33_cell_3 = row33.createCell(3);
		// 设置单元格内容
		row33_cell_3.setCellValue("*专利类型：1发明专利 2实用新型专利  3外观设计");// 需要插入的数据
		// 应用样式
		row33_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(zlsmonrow, zlsmonrow, 3, 10));

		// 专利总跨行数
		//sheet.addMergedRegion(new CellRangeAddress(celllastrownum, zlsmonrow, 1, 2));
		
		int softmaxrownumzl = celllastrownum + softsizezl+1;
		if (softmaxrownumzl > celllastrownum) {
			sheet.addMergedRegion(new CellRangeAddress(celllastrownum, softmaxrownumzl, 1, 2));
		} else {
			sheet.addMergedRegion(new CellRangeAddress(celllastrownum, softmaxrownumzl, 1, 2));
		}
		

		// 软件著作权
		int softeditrownum = sheet.getLastRowNum() + 1;
		HSSFRow row34 = (HSSFRow) sheet.createRow(softeditrownum);
		row34.setHeight((short) 800);
		HSSFCell row34_cell_1 = row34.createCell(1);
		HSSFCell row34_cell_2 = row34.createCell(3);
		HSSFCell row34_cell_3 = row34.createCell(5);
		HSSFCell row34_cell_4 = row34.createCell(8);
		HSSFCell row34_cell_5 = row34.createCell(9);
		// 设置单元格内容
		row34_cell_1.setCellValue("*软件著作权");
		row34_cell_2.setCellValue("软件著作权名");
		row34_cell_3.setCellValue("软件著作权人");// 需要插入的数据
		row34_cell_4.setCellValue("登记号");
		row34_cell_5.setCellValue("获得时间");
		// row34_cell_6.setCellValue("获得时间");
		// 应用样式
		row34_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row34_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row34_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row34_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row34_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]

		sheet.addMergedRegion(new CellRangeAddress(softeditrownum, softeditrownum, 3, 4));
		sheet.addMergedRegion(new CellRangeAddress(softeditrownum, softeditrownum, 5, 7));
		sheet.addMergedRegion(new CellRangeAddress(softeditrownum, softeditrownum, 9, 10));

		int softonrownum = sheet.getLastRowNum() + 1;

		int softsize = 0;
		if (basicdatas.getCscoretecsoftcopyright() != null) {
			softsize = basicdatas.getCscoretecsoftcopyright().size();
			for (int i = 0; i < softsize; i++) {
				HSSFRow row30 = (HSSFRow) sheet.createRow(softonrownum + i);
				row30.setHeight((short) 800);
				HSSFCell row30_cell_3 = row30.createCell(3);
				HSSFCell row30_cell_5 = row30.createCell(5);
				HSSFCell row30_cell_8 = row30.createCell(8);
				HSSFCell row30_cell_9 = row30.createCell(9);
				row30_cell_3.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscoretecsoftcopyright().get(i).getCopyright_name()));// 需要插入的数据
				row30_cell_5.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscoretecsoftcopyright().get(i).getCopyright_person()));
				row30_cell_8.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscoretecsoftcopyright().get(i).getCopyright_num()));
				row30_cell_9.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscoretecsoftcopyright().get(i).getReceive_time()));
				sheet.addMergedRegion(new CellRangeAddress(softonrownum + i, softonrownum + i, 3, 4));
				sheet.addMergedRegion(new CellRangeAddress(softonrownum + i, softonrownum + i, 5, 7));
				sheet.addMergedRegion(new CellRangeAddress(softonrownum + i, softonrownum + i, 9, 10));

				row30_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_9.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格

			}
		}else{
			softsize=1;
			int onrownum=sheet.getLastRowNum()+1;
			HSSFRow row30 = (HSSFRow) sheet.createRow(onrownum);
			row30.setHeight((short) 800);
			HSSFCell row30_cell_3 = row30.createCell(3);
			HSSFCell row30_cell_5 = row30.createCell(5);
			HSSFCell row30_cell_8 = row30.createCell(8);
			HSSFCell row30_cell_9 = row30.createCell(9);
			row30_cell_3.setCellValue("无");// 需要插入的数据
			row30_cell_5.setCellValue("无");
			row30_cell_8.setCellValue("无");
			row30_cell_9.setCellValue("无");
			sheet.addMergedRegion(new CellRangeAddress(onrownum , onrownum , 3, 4));
			sheet.addMergedRegion(new CellRangeAddress(onrownum , onrownum , 5, 7));
			sheet.addMergedRegion(new CellRangeAddress(onrownum , onrownum , 9, 10));

			row30_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_9.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格	
		}

		
		
		int softmaxrownum = softeditrownum + softsize;
		if (softmaxrownum > softeditrownum) {
			sheet.addMergedRegion(new CellRangeAddress(softeditrownum, softmaxrownum, 1, 2));
		} else {
			sheet.addMergedRegion(new CellRangeAddress(softeditrownum, softeditrownum, 1, 2));
		}

		// 药品批文
		int lyeditrownum = sheet.getLastRowNum() + 1;
		HSSFRow yprow = (HSSFRow) sheet.createRow(lyeditrownum);
		yprow.setHeight((short) 800);
		HSSFCell yprow_cell_2 = yprow.createCell(1);
		HSSFCell yprow_cell_3 = yprow.createCell(3);
		HSSFCell yprow_cell_4 = yprow.createCell(5);
		HSSFCell yprow_cell_5 = yprow.createCell(6);
		HSSFCell yprow_cell_6 = yprow.createCell(8);
		HSSFCell yprow_cell_7 = yprow.createCell(9);
		// 设置单元格内容
		yprow_cell_2.setCellValue("药品批文");
		yprow_cell_3.setCellValue("药品名称");
		yprow_cell_4.setCellValue("国家新药");// 需要插入的数据
		yprow_cell_5.setCellValue("国家一级中药保护品种");
		yprow_cell_6.setCellValue("药品批准文号");
		yprow_cell_7.setCellValue("有效日期");
		// 应用样式
		yprow_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		yprow_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		yprow_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		yprow_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		yprow_cell_6.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		yprow_cell_7.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(lyeditrownum, lyeditrownum, 3, 4));
		sheet.addMergedRegion(new CellRangeAddress(lyeditrownum, lyeditrownum, 6, 7));
		sheet.addMergedRegion(new CellRangeAddress(lyeditrownum, lyeditrownum, 9, 10));

		int yppwsize = 0;
		// System.out.println("basicdatas.getCsCoreTecDrugApproval()"+basicdatas.getCsCoreTecDrugApproval());
		if (basicdatas.getCsCoreTecDrugApproval() != null) {
			if (basicdatas.getCsCoreTecDrugApproval().size() > 0) {
				yppwsize = basicdatas.getCsCoreTecDrugApproval().size();
				for (int i = 0; i < yppwsize; i++) {
					int yppwonrownum = sheet.getLastRowNum() + 1;
					HSSFRow row30 = (HSSFRow) sheet.createRow(yppwonrownum + i);
					row30.setHeight((short) 800);
					HSSFCell row30_cell_3 = row30.createCell(3);
					HSSFCell row30_cell_5 = row30.createCell(5);
					HSSFCell row30_cell_7 = row30.createCell(7);
					HSSFCell row30_cell_8 = row30.createCell(8);
					HSSFCell row30_cell_9 = row30.createCell(9);
					row30_cell_3.setCellValue(ExportUntil.getneedvalue(basicdatas.getCsCoreTecDrugApproval().get(i).getDrug_name()));// 需要插入的数据
					row30_cell_5.setCellValue(ExportUntil.getneedvalue(basicdatas.getCsCoreTecDrugApproval().get(i).getNew_drug()));
					row30_cell_7.setCellValue(ExportUntil.getneedvalue(basicdatas.getCsCoreTecDrugApproval().get(i).getProtect_drug()));
					row30_cell_8.setCellValue(ExportUntil.getneedvalue(basicdatas.getCsCoreTecDrugApproval().get(i).getDrug_num()));
					row30_cell_9.setCellValue(ExportUntil.getneedvalue(basicdatas.getCsCoreTecDrugApproval().get(i).getActive_time()));
					sheet.addMergedRegion(new CellRangeAddress(yppwonrownum + i, yppwonrownum + i, 3, 4));
					sheet.addMergedRegion(new CellRangeAddress(yppwonrownum + i, yppwonrownum + i, 5, 7));
					sheet.addMergedRegion(new CellRangeAddress(yppwonrownum + i, yppwonrownum + i, 9, 10));
					row30_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
					row30_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
					row30_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
					row30_cell_9.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				}
			} else {
				yppwsize = 1;
				int yppwonrownum = sheet.getLastRowNum() + 1;
				HSSFRow row30 = (HSSFRow) sheet.createRow(yppwonrownum);
				row30.setHeight((short) 800);
				HSSFCell row30_cell_3 = row30.createCell(3);
				HSSFCell row30_cell_5 = row30.createCell(5);
				HSSFCell row30_cell_7 = row30.createCell(7);
				HSSFCell row30_cell_8 = row30.createCell(8);
				HSSFCell row30_cell_9 = row30.createCell(9);
				row30_cell_3.setCellValue("无");// 需要插入的数据
				row30_cell_5.setCellValue("无");
				row30_cell_7.setCellValue("无");
				row30_cell_8.setCellValue("无");
				row30_cell_9.setCellValue("无");
				sheet.addMergedRegion(new CellRangeAddress(yppwonrownum, yppwonrownum, 3, 4));
				sheet.addMergedRegion(new CellRangeAddress(yppwonrownum, yppwonrownum, 5, 7));
				sheet.addMergedRegion(new CellRangeAddress(yppwonrownum, yppwonrownum, 9, 10));
				
				row30_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row30_cell_9.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			}

		} else {
			yppwsize = 1;
			int yppwonrownum = sheet.getLastRowNum() + 1;
			HSSFRow row30 = (HSSFRow) sheet.createRow(yppwonrownum);
			row30.setHeight((short) 800);
			HSSFCell row30_cell_3 = row30.createCell(3);
			HSSFCell row30_cell_5 = row30.createCell(5);
			HSSFCell row30_cell_7 = row30.createCell(7);
			HSSFCell row30_cell_8 = row30.createCell(8);
			HSSFCell row30_cell_9 = row30.createCell(9);
			row30_cell_3.setCellValue("无");// 需要插入的数据
			row30_cell_5.setCellValue("无");
			row30_cell_7.setCellValue("无");
			row30_cell_8.setCellValue("无");
			row30_cell_9.setCellValue("无");
			sheet.addMergedRegion(new CellRangeAddress(yppwonrownum, yppwonrownum, 3, 4));
			sheet.addMergedRegion(new CellRangeAddress(yppwonrownum, yppwonrownum, 5, 7));
			sheet.addMergedRegion(new CellRangeAddress(yppwonrownum, yppwonrownum, 9, 10));

			row30_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_5.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_8.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row30_cell_9.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		}

		int yappmaxwrownum1 = lyeditrownum + yppwsize;
		if (yappmaxwrownum1 > lyeditrownum) {
			sheet.addMergedRegion(new CellRangeAddress(lyeditrownum, yappmaxwrownum1, 1, 2));
		}

		/*
		 * * 医疗器械
		 * 
		 */
		int ylqxonrownum = sheet.getLastRowNum() + 1;
		HSSFRow row38 = (HSSFRow) sheet.createRow(ylqxonrownum);
		row38.setHeight((short) 800);
		HSSFCell row38_cell_1 = row38.createCell(1);
		HSSFCell row38_cell_2 = row38.createCell(3);
		HSSFCell row38_cell_3 = row38.createCell(5);
		HSSFCell row38_cell_4 = row38.createCell(9);
		// 设置单元格内容
		row38_cell_1.setCellValue("医疗器械注册证");
		row38_cell_2.setCellValue("产品名称");
		row38_cell_3.setCellValue("医疗器械注册号");// 需要插入的数据
		row38_cell_4.setCellValue("有效日期");
		// 应用样式
		row38_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row38_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row38_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row38_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]

		sheet.addMergedRegion(new CellRangeAddress(ylqxonrownum, ylqxonrownum, 3, 4));
		sheet.addMergedRegion(new CellRangeAddress(ylqxonrownum, ylqxonrownum, 5, 8));
		sheet.addMergedRegion(new CellRangeAddress(ylqxonrownum, ylqxonrownum, 9, 10));

		int ypqxsize = 0;
		if (basicdatas.getCscoretecmedicaldeviceregistration() != null) {
			if (basicdatas.getCscoretecmedicaldeviceregistration().size() > 0) {
				// System.out.println("========");
				// System.out.println("basicdatas.getCscoretecmedicaldeviceregistration()"+basicdatas.getCscoretecmedicaldeviceregistration().size());
				ypqxsize = basicdatas.getCscoretecmedicaldeviceregistration().size();
				for (int i = 0; i < ypqxsize; i++) {
					int ylqxvaluenum = sheet.getLastRowNum() + 1;
					HSSFRow row39 = (HSSFRow) sheet.createRow(ylqxvaluenum);
					row39.setHeight((short) 800);
					HSSFCell row39_cell_1 = row39.createCell(1);
					HSSFCell row39_cell_2 = row39.createCell(3);
					HSSFCell row39_cell_3 = row39.createCell(5);
					HSSFCell row39_cell_4 = row39.createCell(9);

					// 设置单元格内容
					row39_cell_2.setCellValue(
							basicdatas.getCscoretecmedicaldeviceregistration().get(i).getInstrument_name());
					row39_cell_3.setCellValue(
							basicdatas.getCscoretecmedicaldeviceregistration().get(i).getRegistration_number());// 需要插入的数据
					row39_cell_4
							.setCellValue(basicdatas.getCscoretecmedicaldeviceregistration().get(i).getActive_time());

					row39_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
					row39_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
					row39_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
					row39_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格

					sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 3, 4));
					sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 5, 8));
					sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 9, 10));
				}
			} else {
				ypqxsize = 1;
				int ylqxvaluenum = sheet.getLastRowNum() + 1;
				HSSFRow row39 = (HSSFRow) sheet.createRow(ylqxvaluenum);
				row39.setHeight((short) 800);
				HSSFCell row39_cell_1 = row39.createCell(1);
				HSSFCell row39_cell_2 = row39.createCell(3);
				HSSFCell row39_cell_3 = row39.createCell(5);
				HSSFCell row39_cell_4 = row39.createCell(9);

				// 设置单元格内容
				row39_cell_2.setCellValue("无");
				row39_cell_3.setCellValue("无");// 需要插入的数据
				row39_cell_4.setCellValue("无");

				row39_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row39_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row39_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row39_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格

				sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 3, 4));
				sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 5, 8));
				sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 9, 10));

			}

		} else {
			ypqxsize = 1;
			int ylqxvaluenum = sheet.getLastRowNum() + 1;
			HSSFRow row39 = (HSSFRow) sheet.createRow(ylqxvaluenum);
			row39.setHeight((short) 800);
			HSSFCell row39_cell_1 = row39.createCell(1);
			HSSFCell row39_cell_2 = row39.createCell(3);
			HSSFCell row39_cell_3 = row39.createCell(5);
			HSSFCell row39_cell_4 = row39.createCell(9);

			// 设置单元格内容
			row39_cell_2.setCellValue("无");
			row39_cell_3.setCellValue("无");// 需要插入的数据
			row39_cell_4.setCellValue("无");

			row39_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row39_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row39_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row39_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格

			sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 3, 4));
			sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 5, 8));
			sheet.addMergedRegion(new CellRangeAddress(ylqxvaluenum, ylqxvaluenum, 9, 10));

		}
		// sheet.addMergedRegion(new CellRangeAddress(ylqxonrownum,
		// ylqxvaluenum+ypqxsize, 1, 2));
		int yappmaxwrownum = ylqxonrownum + ypqxsize;
		if (yappmaxwrownum > ylqxonrownum) {
			sheet.addMergedRegion(new CellRangeAddress(ylqxonrownum, yappmaxwrownum, 1, 2));
		}

		/*
		 * * 企业参与国际或国家或行业标准制定情况
		 * 
		 */
		int commdzz = sheet.getLastRowNum() + 1;
		HSSFRow row40 = (HSSFRow) sheet.createRow(commdzz);
		row40.setHeight((short) 800);
		HSSFCell row40_cell_1 = row40.createCell(1);
		// 设置单元格内容
		row40_cell_1.setCellValue("企业参与国际或国家或行业标准制定情况表");// 需要插入的数据
		// 应用样式
		row40_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(commdzz, commdzz, 1, 10));

		// int lastcell=0;
		int ccount = 0;

		int commdzzvalue = sheet.getLastRowNum() + 1;
		HSSFRow row41 = (HSSFRow) sheet.createRow(commdzzvalue + ccount);
		row41.setHeight((short) 800);
		HSSFCell row41_cell_0 = row41.createCell(0);
		HSSFCell row41_cell_1 = row41.createCell(1);
		HSSFCell row41_cell_2 = row41.createCell(3);
		HSSFCell row41_cell_3 = row41.createCell(5);
		HSSFCell row41_cell_4 = row41.createCell(9);
		// 设置单元格内容
		row41_cell_1.setCellValue("标准名称");
		row41_cell_2.setCellValue("标准级别");
		row41_cell_3.setCellValue("标准编号");// 需要插入的数据
		row41_cell_4.setCellValue("起草单位中的地位");
		// 应用样式
		row41_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row41_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row41_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row41_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row41_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(commdzzvalue + ccount, commdzzvalue + ccount, 1, 2));
		sheet.addMergedRegion(new CellRangeAddress(commdzzvalue + ccount, commdzzvalue + ccount, 3, 4));
		sheet.addMergedRegion(new CellRangeAddress(commdzzvalue + ccount, commdzzvalue + ccount, 5, 8));
		sheet.addMergedRegion(new CellRangeAddress(commdzzvalue + ccount, commdzzvalue + ccount, 9, 10));
		if (basicdatas.getCscorestandardformulation() != null) {
			for (int i = 0; i < basicdatas.getCscorestandardformulation().size(); i++) {
				/*
				 * * 企业参数值
				 */
				int cnmslj = sheet.getLastRowNum() + 1;
				HSSFRow row42 = (HSSFRow) sheet.createRow(cnmslj + ccount);
				row42.setHeight((short) 800);
				HSSFCell row42_cell_0 = row42.createCell(0);
				HSSFCell row42_cell_1 = row42.createCell(1);
				HSSFCell row42_cell_2 = row42.createCell(3);
				HSSFCell row42_cell_3 = row42.createCell(5);
				HSSFCell row42_cell_4 = row42.createCell(9);
				// 设置单元格内容
				row42_cell_1.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscorestandardformulation().get(i).getName()));
				row42_cell_2.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscorestandardformulation().get(i).getLevel()));
				row42_cell_3.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscorestandardformulation().get(i).getCode()));// 需要插入的数据
				row42_cell_4.setCellValue(
						ExportUntil.getneedvalue(basicdatas.getCscorestandardformulation().get(i).getStatus()));
				// 应用样式
				row42_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row42_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row42_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row42_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				row42_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
				// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
				sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 1, 2));
				sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 3, 4));
				sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 5, 8));
				sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 9, 10));

			}
		} else {

			/*
			 * * 企业参数值
			 */
			int cnmslj = sheet.getLastRowNum() + 1;
			HSSFRow row42 = (HSSFRow) sheet.createRow(cnmslj + ccount);
			row42.setHeight((short) 800);
			HSSFCell row42_cell_0 = row42.createCell(0);
			HSSFCell row42_cell_1 = row42.createCell(1);
			HSSFCell row42_cell_2 = row42.createCell(3);
			HSSFCell row42_cell_3 = row42.createCell(5);
			HSSFCell row42_cell_4 = row42.createCell(9);
			// 设置单元格内容
			row42_cell_1.setCellValue("无");
			row42_cell_2.setCellValue("无");
			row42_cell_3.setCellValue("无");// 需要插入的数据
			row42_cell_4.setCellValue("无");
			// 应用样式
			row42_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row42_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row42_cell_2.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row42_cell_3.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			row42_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
			// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
			sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 1, 2));
			sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 3, 4));
			sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 5, 8));
			sheet.addMergedRegion(new CellRangeAddress(cnmslj + ccount, cnmslj + ccount, 9, 10));

		}

		/*
		 * * 集成电路分布
		 */
		int jcdlonrownum = sheet.getLastRowNum() + 1;
		HSSFRow row43 = (HSSFRow) sheet.createRow(jcdlonrownum + ccount);
		row43.setHeight((short) 800);
		HSSFCell row43_cell_1 = row43.createCell(1);
		// 设置单元格内容
		if ("1".equals(basicdatas.getCscoretechnology().getIs_ic_layout())) {
			row43_cell_1.setCellValue("集成电路:是");// 需要插入的数据
		} else {
			row43_cell_1.setCellValue("集成电路：否");// 需要插入的数据
		}

		// 应用样式
		row43_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(jcdlonrownum + ccount, jcdlonrownum + ccount, 1, 10));

		int otheronrownums = sheet.getLastRowNum() + 1;
		HSSFRow row44 = (HSSFRow) sheet.createRow(otheronrownums + ccount);
		row44.setHeight((short) 800);
		HSSFCell row44_cell_1 = row44.createCell(1);
		// 设置单元格内容
		if ("1".equals(basicdatas.getCscoretechnology().getIs_other())) {
			row44_cell_1.setCellValue("其他:" + basicdatas.getCscoretechnology().getOther_content());// 需要插入的数据
		} else {
			row44_cell_1.setCellValue("其他:无");// 需要插入的数据
		}

		// 应用样式
		row44_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(otheronrownums + ccount, otheronrownums + ccount, 1, 10));
		int jslyonrownum = sheet.getLastRowNum() + 1;
		HSSFRow row45 = (HSSFRow) sheet.createRow(jslyonrownum + ccount);
		row45.setHeight((short) 800);
		HSSFCell row45_cell_1 = row45.createCell(1);
		// 设置单元格内容
		if ("1".equals(basicdatas.getCscoretechnology().getTec_source())) {
			row45_cell_1.setCellValue("技术来源：" + "独立知识产权");// 需要插入的数据
		} else if ("2".equals(basicdatas.getCscoretechnology().getTec_source())) {
			row45_cell_1.setCellValue("技术来源：" + "合作研发");// 需要插入的数据
		} else if ("3".equals(basicdatas.getCscoretechnology().getTec_source())) {
			row45_cell_1.setCellValue("技术来源：" + "购买技术");// 需要插入的数据
		} else if ("4".equals(basicdatas.getCscoretechnology().getTec_source())) {
			row45_cell_1.setCellValue("技术来源：" + "其他:" + basicdatas.getCscoretechnology().getOther_source());// 需要插入的数据
		}

		// 应用样式
		row45_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(jslyonrownum + ccount, jslyonrownum + ccount, 1, 10));
		int kjcgzhlyonrownum = sheet.getLastRowNum() + 1;
		HSSFRow row46 = (HSSFRow) sheet.createRow(kjcgzhlyonrownum + ccount);
		row46.setHeight((short) 800);
		HSSFCell row46_cell_0 = row46.createCell(0);
		HSSFCell row46_cell_1 = row46.createCell(1);
		HSSFCell row46_cell_4 = row46.createCell(4);
		// 设置单元格内容
		row46_cell_1.setCellValue("科技成果转化来源");// 需要插入的数据
		if ("1".equals(basicdatas.getCscoretechnology().getTec_conversion())) {
			row46_cell_4.setCellValue("高校/科研院所名称：" + (basicdatas.getCscoretechnology().getUniversities_name() == null
					? "" : basicdatas.getCscoretechnology().getUniversities_name()));// 需要插入的数据
		} else if ("2".equals(basicdatas.getCscoretechnology().getTec_conversion())) {
			row46_cell_4.setCellValue("相关科技计划" + " 计划名称：" + basicdatas.getCscoretechnology().getPlan_name());// 需要插入的数据
		} else if ("3".equals(basicdatas.getCscoretechnology().getTec_conversion())) {
			row46_cell_4.setCellValue("自行研发");// 需要插入的数据
		} else if ("4".equals(basicdatas.getCscoretechnology().getTec_conversion())) {
			row46_cell_4.setCellValue("其他");// 需要插入的数据
		}

		// 应用样式
		row46_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row46_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row46_cell_4.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
		sheet.addMergedRegion(new CellRangeAddress(kjcgzhlyonrownum + ccount, kjcgzhlyonrownum + ccount, 1, 3));
		sheet.addMergedRegion(new CellRangeAddress(kjcgzhlyonrownum + ccount, kjcgzhlyonrownum + ccount, 4, 10));

		int gjcyonrownum = sheet.getLastRowNum() + 1;
		HSSFRow row47 = (HSSFRow) sheet.createRow(gjcyonrownum + ccount);
		row47.setHeight((short) 800);
		HSSFCell row47_cell_0 = row47.createCell(0);
		HSSFCell row47_cell_1 = row47.createCell(1);
		// 设置单元格内容
		row47_cell_0.setCellValue("关键词");// 需要插入的数据
		if (basicdatas.getCskeyword() != null) {
			if (basicdatas.getCskeyword().getKeyword() != null && basicdatas.getCskeyword().getKeyword().length() > 0) {
				row47_cell_1.setCellValue(basicdatas.getCskeyword().getKeyword());// 需要插入的数据
			} else {
				row47_cell_1.setCellValue("无");// 需要插入的数据
			}
		} else {
			row47_cell_1.setCellValue("无");// 需要插入的数据
		}

		// 应用样式
		row47_cell_0.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		row47_cell_1.setCellStyle(excelstyle.getCellStyleheader());// 应用到单元格
		// 合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]

		sheet.addMergedRegion(new CellRangeAddress(gjcyonrownum + ccount, gjcyonrownum + ccount, 1, 10));

		// 设置核心技术跨行
		sheet.addMergedRegion(new CellRangeAddress(celllastrownum, sheet.getLastRowNum() - 1, 0, 0));

	}
}
